from django.db import models

# Create your models here.
class allcourses(models.Model):
	department = models.TextField(db_column='Department') # Field name made lowercase.
	class_field = models.TextField(db_column='Class') # Field renamed because it was a Python reserved word. Field name made lowercase.
	weight = models.TextField(db_column='Weight') # Field name made lowercase.
	name = models.TextField(db_column='Name') # Field name made lowercase.
	courseid = models.IntegerField(db_column='courseid')
	section = models.TextField(db_column='Section') # Field name made lowercase.
	campus = models.TextField(db_column='Campus') # Field name made lowercase.
	enrolcap = models.IntegerField(db_column='EnrolCap') # Field name made lowercase.
	enroltotal = models.IntegerField(db_column='EnrolTotal') # Field name made lowercase.
	schedule = models.TextField(db_column='Schedule') # Field name made lowercase.
	building = models.TextField(db_column='Building') # Field name made lowercase.
	instructor = models.TextField(db_column='Instructor') # Field name made lowercase.
	description = models.TextField(db_column='Description') # Field name made lowercase.
	prereq = models.TextField(db_column='PreReq') # Field name made lowercase.
	coreq = models.TextField(db_column='CoReq') # Field name made lowercase.
	antireq = models.TextField(db_column='AntiReq') # Field name made lowercase
	name_classfield = models.TextField(max_length=45, primary_key=True, db_column='nameClassfield')

class winter09(models.Model):
	department = models.TextField(db_column='Department') # Field name made lowercase.
	class_field = models.TextField(db_column='Class') # Field renamed because it was a Python reserved word. Field name made lowercase.
	weight = models.TextField(db_column='Weight') # Field name made lowercase.
	name = models.TextField(db_column='Name') # Field name made lowercase.
	courseid = models.IntegerField(db_column='courseid', primary_key=True)
	section = models.TextField(db_column='Section') # Field name made lowercase.
	campus = models.TextField(db_column='Campus') # Field name made lowercase.
	enrolcap = models.IntegerField(db_column='EnrolCap') # Field name made lowercase.
	enroltotal = models.IntegerField(db_column='EnrolTotal') # Field name made lowercase.
	schedule = models.TextField(db_column='Schedule') # Field name made lowercase.
	building = models.TextField(db_column='Building') # Field name made lowercase.
	instructor = models.TextField(db_column='Instructor') # Field name made lowercase.
	description = models.TextField(db_column='Description') # Field name made lowercase.
	prereq = models.TextField(db_column='PreReq') # Field name made lowercase.
	coreq = models.TextField(db_column='CoReq') # Field name made lowercase.
	antireq = models.TextField(db_column='AntiReq') # Field name made lowercase
	name_classfield = models.TextField(db_column='nameClassfield')
	profRating = models.IntegerField(db_column='profRating')
	profLink = models.TextField(db_column='profLink')
	
class spring09(models.Model):
	department = models.TextField(db_column='Department') # Field name made lowercase.
	class_field = models.TextField(db_column='Class') # Field renamed because it was a Python reserved word. Field name made lowercase.
	weight = models.TextField(db_column='Weight') # Field name made lowercase.
	name = models.TextField(db_column='Name') # Field name made lowercase.
	courseid = models.IntegerField(db_column='courseid', primary_key=True)
	section = models.TextField(db_column='Section') # Field name made lowercase.
	campus = models.TextField(db_column='Campus') # Field name made lowercase.
	enrolcap = models.IntegerField(db_column='EnrolCap') # Field name made lowercase.
	enroltotal = models.IntegerField(db_column='EnrolTotal') # Field name made lowercase.
	schedule = models.TextField(db_column='Schedule') # Field name made lowercase.
	building = models.TextField(db_column='Building') # Field name made lowercase.
	instructor = models.TextField(db_column='Instructor') # Field name made lowercase.
	description = models.TextField(db_column='Description') # Field name made lowercase.
	prereq = models.TextField(db_column='PreReq') # Field name made lowercase.
	coreq = models.TextField(db_column='CoReq') # Field name made lowercase.
	antireq = models.TextField(db_column='AntiReq') # Field name made lowercase
	name_classfield = models.TextField(db_column='nameClassfield')
	profRating = models.IntegerField(db_column='profRating')
	profLink = models.TextField(db_column='profLink')
	
class fall09(models.Model):
	department = models.TextField(db_column='Department') # Field name made lowercase.
	class_field = models.TextField(db_column='Class') # Field renamed because it was a Python reserved word. Field name made lowercase.
	weight = models.TextField(db_column='Weight') # Field name made lowercase.
	name = models.TextField(db_column='Name') # Field name made lowercase.
	courseid = models.IntegerField(db_column='courseid', primary_key=True)
	section = models.TextField(db_column='Section') # Field name made lowercase.
	campus = models.TextField(db_column='Campus') # Field name made lowercase.
	enrolcap = models.IntegerField(db_column='EnrolCap') # Field name made lowercase.
	enroltotal = models.IntegerField(db_column='EnrolTotal') # Field name made lowercase.
	schedule = models.TextField(db_column='Schedule') # Field name made lowercase.
	building = models.TextField(db_column='Building') # Field name made lowercase.
	instructor = models.TextField(db_column='Instructor') # Field name made lowercase.
	description = models.TextField(db_column='Description') # Field name made lowercase.
	prereq = models.TextField(db_column='PreReq') # Field name made lowercase.
	coreq = models.TextField(db_column='CoReq') # Field name made lowercase.
	antireq = models.TextField(db_column='AntiReq') # Field name made lowercase
	name_classfield = models.TextField(db_column='nameClassfield')
	profRating = models.IntegerField(db_column='profRating')
	profLink = models.TextField(db_column='profLink')
